NoSQL database systems are often highly optimized for retrieval and appending operations and often offer little functionality beyond record storage (e.g. key-value stores). The reduced run-time flexibility compared to full SQL systems is compensated by marked gains in scalability and performance for certain data models.

Sep 15, 2010 · NoSQL is a database system where data is organized into the document (MongoDB), key-value pair (MemCache, Redis), and graph structure form(Neo4J). Maybe there are possible questions and answer for "When to go for NoSQL":

Apr 9, 2010 · Document-based NoSQL databases (e.g. MongoDB, CouchDB); Key/Value NoSQL databases (e.g. Redis); Column family NoSQL databases (e.g. Hibase, Cassandra). What we call an Aggregate here, is what Eric Evans defined in its Domain-Driven Design as a self-sufficient of Entities and Value-Objects in a given Bounded Context.

Apr 19, 2019 · "NoSQL" is a buzzword describing a diverse collection of database systems that focus on "semi-structured" data (that do not fit well into a tabular representation), sharding, and high concurrency at the expense of transactional integrity and consistency, the latter being among the basic tenets of relational database management systems (RDBMS).

Oct 29, 2018 · Traditionally, NoSQL was used for unstructured high volumes like logging results, website search data etc. However, with professionals becoming more comfortable with document storage and relational capabilities improved over time, NoSQL is often favoured over traditional relational databases.

Secondly, NoSQL allows you to eke more performance out of the system by eliminating a lot of integrity checks done by relational databases from the database tier. Again, this is similar to how you can get more performance out of your car by driving a manual transmission versus an automatic transmission vehicle.

Apr 21, 2010 · NoSQL solutions usually manage relatively limited schemas with large cardinality in few entities, while data warehouses typically have lots of facts and dimensions (in a dimensional model) or lots of entities in a 3NF model.

Aug 13, 2013 · NoSQL products support a whole range of new data types, and this is a major area of innovation in NoSQL. We have: column-oriented, graph, advanced data structures, document-oriented, and key-value. Complex objects can be easily stored without a lot of mapping.

Jan 11, 2010 · This NoSQL product provides GIS applications the ability to conflate multiple objects into one entity. This provides support for managing relationships across structured and unstructured content, provenance and pedigree information about the data, historic and timeline information, etc. in a single entity.

So ignore the fact that we should just use a NoSQL DB - client infrastructure requirements are getting the way. We have data that obviously belongs in a non-relational model, but we have to use SQL Server 2014 for persistence. Is there a way to use the library for something like RavenDB or MongoDB with SQL Server for persistence?